Opt Level 1.13 - Excel

5 Questions | Total Attempts: 67

SettingsSettingsSettings
Please wait...
Opt Level 1.13 - Excel

Questions and Answers
  • 1. 
    What version of excel am I using at Miller Transporters?
    • A. 

      3.4

    • B. 

      2007 Citrix, 2010 some PCs

    • C. 

      Revision 1.1

    • D. 

      All of the above

  • 2. 
    What is a simple way to find out the sum of a group of numbers in excel?
    • A. 

      Highlight the group of numbers and look in the lower right section of the status bar at the bottom of the worksheet for the answer.

    • B. 

      Use a Function in an empty cell to calculate the total.

    • C. 

      Read the numbers and enter them in your calculator for a quick total.

    • D. 

      Copy the numbers to the first row and click on the Summation Symbol.

  • 3. 
    What is the proper way to sort selected cells in excel?
    • A. 

      Put your cursor on the top row of a column and click SORT on the tool bar.

    • B. 

      Highlight all your data in the sheet that you want to sort and stay together, then click on the SORT toolbar icon, and select the fields you want to sort on.

    • C. 

      Highlight the top of the column you want to sort on, and press CTRL-T.

    • D. 

      Highlight all of your data in the sheet that you want to sort and stay together and press CTRL HOME.

  • 4. 
    What is a shortcut for putting the current date in a cell?
    • A. 

      CTRL;

    • B. 

      CTRL DELETE

    • C. 

      CTRL HOME

    • D. 

      CTRL END

  • 5. 
    What is the quickest way to FIND a value in a spreasheet?
    • A. 

      CTRL F, then enter the value you are looking for and press enter/FIND

    • B. 

      Highlight one column at a time and read down through it until you find your match.

    • C. 

      Sort the data on the field you think your data is in, and then highlight the field and search it.

Related Topics
Back to Top Back to top