Formulas
Ribbon
File
Shortcut
100
Use of formulas
Easily and accurately calculate specific values using a finite command
100
what is the ribbon
Primary command center located at the top of the screen
100
Use of the file Tab
what is to change different aspects and properties of the Excel pages inner workings
100
Used to instantly copy selected items to your clipboard for later use
(Ctrl+C)
200
Use of the Sum formula
=Sum(A5:C7)
what is to instantly and accurately add together a set of variables
200
Use of the ribbon
Quick access to the available commands in the excel program
200
which file tab allows you to create or save your document as a PDF
What is the Export tab
200
Use of (Ctrl+A)
What is to highlight and select an entire text or document
300
How do you copy 1 cells content into another
what is = (the click on the original cell)
300
Name all the tab located in the Ribbon (there are 8)
File, Home, Insert, page Layout, Formulas, Data, Review, View
300
What is the use of the New tab
open up a new document based on a blank workbook or preset templates
300
shortcuts to create open and close a workbook
What is Ctrl+N, Ctrl+O, Ctrl+W
400
In which Formulas sub category can you change variables involving date and time
what is the Function Library
400
which tab can page setup be found in that includes the options to change the background and margins.
What is Page layout
400
The difference between save and save as
what is that save as let you choose where to save a document to where save only saves it to the pre-chosen save file
400
What shortcut helps you repeat the last command or action
What is F4
500
In which Formula sub category can you check for formatting error
Formula Auditing
500
Which Tab gives you the option to create delete and edit comments
What is the Review tab
500
What are 2 ways to protect your workbook through the file tab
what is to enable Read-Only, add a digital signature, protect the current sheet and workbook structure, encrypt with password, or mark as final (only need 2)
500
what is the shortcut F7 used for in Excel
what is to check the spelling