What is the cell in the worksheet in which you can type data?
0%
Main cell
0%
Open cell
100%
Active cell
0%
Absolute cell
Q.4.
The intersection of a row and column.
0%
column
0%
row
100%
cell
0%
active cell
Q.5.
The set of data that runs up and down in a spreadsheet
0%
column
0%
row
0%
cell
100%
active cell
Q.6.
Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below. Which of the following suggestions would help Luisa?
0%
Make the cell wider
0%
Change the number formatting in the cell
0%
Change the font format in the cell
0%
Delete the data and re-type it
Q.7.
Excel is part of
0%
Access
100%
Microsoft Office
0%
PowerPoint
Q.8.
To allow you to evenly distribute a title over a table of numbers, use the
0%
Center button
0%
Merge and Center button
100%
Merge cells only button
Q.9.
How do you change column width to fit the contents?
0%
Single-click the boundary to the left of the column heading
100%
Double-click the boundary to the right of the column heading
0%
Press ALT and single-click anywhere in the column
Q.10.
The cell address of the highlighted cell is
0%
C
0%
4
0%
A4
100%
C4
Q.11.
These are known as
0%
workbooks
0%
worksheets
0%
formula bar
0%
cell
Q.12.
What does the indicated icon do in the red box?
0%
Apply underline
0%
Apply italic
0%
Make text bigger
0%
Apply bold
Q.13.
A formula in the spreadsheet should always start with
0%
a plus sign
0%
an asterisk
100%
an equals sign
0%
a capital letter
Q.14.
Which of these would add up the numbers from A3 to A6
0%
+(A3:A6)
0%
=(A3:A6)
0%
=(Ave(a3:a6))
100%
=Sum(A3:A6)
Q.15.
What are lines that can be applied around worksheet cells or objects?
100%
Gridlines
0%
Borders
0%
Underlines
0%
Boundaries
Q.16.
Excel is part of?
0%
Power Point
0%
Microsoft Office Suite
100%
Access
0%
Google
Q.17.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
0%
Cell Address
0%
Worksheet
100%
Formula
Q.18.
True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
0%
false
0%
true
Q.19.
How do you select an entire column?
100%
Select Edit > Select > Column from the menu
0%
Click the column heading letter
0%
Hold down the shift key as you click anywhere in the column.
0%
Hold down the Ctrl key as you click anywhere in the column
Support mcqexams.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.