Sandra is creating a formula to multiply the values in cells B4 and C4, which formula should she use?
A.=B4+C4
B. =B4*C4
C.=B4xC4
D.=B4-C4
B. =B4*C4
100
Gabriel needs to create a shortcut formula in cell B40 to calculate the total sales located in cells B1 through B39. Which Function should he create?
A.=$B$1+25
B.=B1+25
C. =SUM(B1:B39)
D.=B1:B39
C. =SUM(B1:B39)
100
What area contains the command used to customize the print options in microsoft Excel?
A.Home ribbon
b.Page Layout RIbbon
c. File Tab
D.Quick Access toolbar
What is File Tab
100
Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
A.Word
B.Publisher
C. Excel
D.Powerpoint
What is Excel
100
What is the process of using the mouse to move or copy cells called?
A.Click and Paste
B.Drag and move
C.Dragging
D. Drag and Drop
What is Drag and drop
200
Kathryn needs the text in cell A1 to be angled at 90 degrees. which option should she select?
A.Center
B.Merge and Center
C. Orientation
D.Wrap text
C. Orientation
200
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
A.Freeze panes
B.Split
C.Hide
D. Unhide
D. Unhide
200
What defines the color of the characters in an Excel Worksheet?
A.Font Size
B. Font Color
C.Cell color
D.Background
What is Font Color
200
Which function do you use to insert todays date in a worksheet that is automatically updates each time the worksheet is opened?
A. Today
B.Weekday
C.Date
D.CurrentDate
What is today
200
What command on the home ribbon do you use to format row height and column width, organize sheets, and protect or guide cells in a worksheet?
A.Insert
B.Form
C.Sort & filter
D. Format
What is Format
300
Angit is calculating her average sales for the past four months, if she uses "=AVERAGE(B1:B4)", this is an example of which type of entry?
A.Values
B.Formulas
C.Labels
D. Functions
D. Functions
300
Kenyon would like to apply the title format to the data ROw 1 of a spreadsheet. Which formatting style should he select?
A. Cell Style
B.Conditional Formatting
C.Fill Color
D.Format as Table
What is Cell Style
300
Where can you find the insert function button in Excel?
A.Quick access toolbar
B. Formula Bar
C.Status Bar
D.Shortcut Bar
What is formula Bar
300
Which Dialogue box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
A.Number
B.Font
C.Paragraph
D. Format Cells
What is Format Cells
300
What notebook-like feature organizes sheets in excel?
A. Workbook
B.Worksheet
C.NotePad
D.Folder
What is workbook
400
Amanda has created a spreadsheet containing test grades for the first nine weeks, which function should she use to estimate the grade on her next test?
A. Average
B.Max
C.Min
D.Sum
What is Average
400
Bob the Builder needs to identify the values in column B for a statistics Report, which type of entry should he use in the column field?
A.Values
B.Formulas
C. Labels
D.Functions
What is Labels
400
What command do you use to apply a background color in a worksheet?
A.Drawing
B. FIll COlor
C.Borders & Shading
D.Highlight
What is Fill Color
400
Which feature was created for users who prefer keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with ALt Key?
A.Quick Access Toolbar
B.Hot Keys
C.Mini Toolbar
D. Key tips
What is Key Tips
400
What view enables a user to create or modify a worksheet while seeing how it will look in printed format?
A. Page Layout
B.Print
C.Normal
D.Web
What is page layout
500
Joan wants to add a new entry to the bottom of her spreadsheet, what is the shortcut that will take her to the last record on her spreadsheet?
A.Ctrl + Home
B. CTRL + End
C.CTRL + Up Arrow
D.CTRL + 1
B. CTRL + End
500
BananaMan needs to identify the values in column B for a sales report, what type of entry should he use in the column header?
A.Values
B.Formulas
C. Labels
D.Functions
Labels
500
Carl notices that the data in cell E4 reads ####, what command could carl choose to correct this problem?
A. AutoFIt
B.Special formatting
C.Subscript Formatting
D.Warp text
What is Autofit
500
Which Ribbon command on the page layout ribbon enables a user to mark where a new page will begin on the printed copy?
A.Print Area
B. Breaks
C.Background
D.Effects
What is Breaks
500
What command on the fill options dialogue box is the default option if you enter a month or day?
A.Copy Cells
B.Fill Formatting cells
C.fill without formatting
D. Fill Series