• Which keyboard shortcut is used to quickly save a workbook in Excel?
    A. Ctrl + S
    B. Ctrl + P
    C. Ctrl + Z
    D. Ctrl + X

  • What is the quickest way to apply bold formatting to a selected text in an Excel cell?

    A. Press Ctrl + B
    B. Click on the "Home" tab, then "Bold"
    C. Right-click and choose "Bold"
    D. All of the above

  • What function is inserted when you click the AutoSum (∑) button in Excel by default?

    A. COUNT
    B. SUM
    C. AVERAGE
    D. MAX

  • Which formula correctly calculates the total cost if ‘Price’ is in cell A1 and ‘Quantity’ is in B1?

    A. =A1+B1
    B. =A1*B1
    C. =SUM(A1:B1)
    D. =SUM:A1*B1

  • What conditional rule would I use to highlight the 3 best sales persons in a list of 20?

    A. Between…0 & 3
    B. Above Average…
    C. Equal to… 3
    D. Top 10 %… Edit 15%

  • ¿Cuál de las siguientes es la mejor manera de congelar la fila superior de una hoja en Excel?

    A. Select the row, then press Ctrl + F
    B. Click on "View" → "Freeze Panes" → "Freeze Top Row"
    C. Click on "Home" → "Sort & Filter"
    D. None of the above

  • Which is the short-key to make a horizontal Autosum?

    A. Cmmd + S

    B. Cmmd + Shift + D

    C. Select row + Cmmd + Shift + =

    D. Cmmd + Shift + T

  • Which tab allows you to create a new workbook from a template in Excel?

    A. File
    B. Page Layout
    C. Insert
    D. View

  • Which Excel chart type is best suited for showing trends over time?

    A. Pie Chart
    B. Column Chart
    C. Line Chart
    D. Radar Chart

  • How do I fix the numbers on my X-axis inside my graph?

    A. Chart Design → Y values
    B. Page Layout View
    C. Format → Plot area
    D. None of the above

Download Answers