Indeed Excel Quiz.docx - Whatu2019s the correct sorting...

This preview shows page 1 - 2 out of 3 pages.

What’s the correct sorting function to list Colors in alphabetical order (A to Z)ColorNumberBlue120A to Z = ASCENDINGGreen85Z to A = DESCENDINGOrange112EQUAL to A to ZRed100Yellow90 1)What does clicking the + sign below do? 2)What is the correct keyboard shortcut to cut a cell value? 3)In a new worksheet, what’s the correct formula to reference Cell A1 from the ALPHA worksheet?a.=ALPHA?A1b.=A1c.=ALPHA!A1d.=”ALPHA”A1e.=’ALPHA’A1 4)Based on the values in Cells B77:B81, what function can automatically return the value in Cell C77?A8Sales9$794 $1,020 =MAX(A9:A13)' 10$721 11$854 12$912 13$1,020 5)What does clicking and dragging the fill handle indicated by the cursor do?SalesTax$794$64 $721$58 $854 $912 $1,020

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture