Calgary Admin Welcome to your quiz for Administrative and Clerical positions. 1) Put the following folders for the following clients in alphabetical order:a) Jeffries Accountb) Smith Accountc) James Accountd) Takashi Account a, b, c, d b, d, a, c c, a, b, d c, b, a, d 2) Erica worked 16 hours last week and 24 hours this week. She also worked 1 hour of OT this week and was paid time-and-a-half for that hour. If she earns $15.50 per hour - how much has she earned during these two weeks (before taxes)? a) $634.50 b) $643.25 c) $620.25 d) $635.50 3) Which outfit would be MOST LIKELY to be considered NOT "Business Casual" or inappropriate for an office environment: A B C D E None of the above - they are all appropriate for an office. 4) Which outfit would be MOST LIKELY to be considered NOT "Business Casual" or inappropriate for an office environment? A B C D E None of these - they are all appropriate for an office. You are asked to do a weekly sales report and add up the # of cards collected.What is the formula you put in Cell B6 (Highlighted cell) below: =Sum(B2:B5) =Addup(B2:B5) =Count(B2:B5) =Countup(B2:B5) Either A or C Revenues are expected to be up 10% in every branch! You've been asked to prepare a quick spreadsheet - for insertion into a PowerPoint. The figures in some cells are appearing as ####### instead of numbers. The most likely explanation is: The formulas are wrong. The cells are not wide enough. This is what's called a "circular reference". The formulas are referring to empty cells. Time's up
