Excel – Code Vapor
What Excel Class Do You Need?
Answer a few questions and we will tell you what class you should take, core or intermediate.
What is the main purpose of Excel?
Create a text document with formatting
Create a document that allows columns and rows to be added or multiplied
Create graphs based upon a table of numbers
If you wanted to multiply 23 by 2, what is the correct formula, where 23 is contained in A3
23 * 2
2 * 23 =
= 23 * 2
A3 * 2
If you had a column of 5 numbers you wanted to add together, and the first number was in A1, what formula would be the best choice?
= (A1...A5, +)
(A1 + A2 + A3 + A4 + A5) =
When you want to print a spreadsheet that fits on one page wide, what should should you do?
In the footer enter "width = 1"
In the page layout menu, select width = automatic
In the page layout menu, select orientation to landscape
Can you reference cells in calculations from a different tab?
What symbol do you use in a formula that will stop auto increment when you copy and paste?
What file format should you save the spreadsheet to when you need to export the data and the other program does not read Excel files?
Ready to send