MCQExams
0:0:1
CBSE
JEE
NTSE
NEET
Practice
Homework
×
Computer Science
Microsoft Excel - Rows, Columns & Cells
The letters in Excel represent the...
Report Question
0%
Rows
0%
Columns
0%
Cells
0%
Data
The numbers in Excel represent the...
Report Question
0%
Rows
0%
Columns
0%
Cells
0%
Data
What is the cell in the worksheet in which you can type data?
Report Question
0%
Main cell
0%
Open cell
0%
Active cell
0%
Absolute cell
The intersection of a row and column.
Report Question
0%
column
0%
row
0%
cell
0%
active cell
The set of data that runs up and down in a spreadsheet
Report Question
0%
column
0%
row
0%
cell
0%
active cell
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?
Report Question
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
Excel is part of
Report Question
0%
Access
0%
Microsoft Office
0%
PowerPoint
To allow you to evenly distribute a title over a table of numbers, use the
Report Question
0%
Center button
0%
Merge and Center button
0%
Merge cells only button
How do you change column width to fit the contents?
Report Question
0%
Single-click the boundary to the left of the column heading
0%
Double-click the boundary to the right of the column heading
0%
Press ALT and single-click anywhere in the column
The cell address of the highlighted cell is
Report Question
0%
C
0%
4
0%
A4
0%
C4
These are known as
Report Question
0%
workbooks
0%
worksheets
0%
formula bar
0%
cell
What does the indicated icon do in the red box?
Report Question
0%
Apply underline
0%
Apply italic
0%
Make text bigger
0%
Apply bold
A formula in the spreadsheet should always start with
Report Question
0%
a plus sign
0%
an asterisk
0%
an equals sign
0%
a capital letter
Which of these would add up the numbers from A3 to A6
Report Question
0%
+(A3:A6)
0%
=(A3:A6)
0%
=(Ave(a3:a6))
0%
=Sum(A3:A6)
What are lines that can be applied around worksheet cells or objects?
Report Question
0%
Gridlines
0%
Borders
0%
Underlines
0%
Boundaries
Excel is part of?
Report Question
0%
Power Point
0%
Microsoft Office Suite
0%
Access
0%
Google
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
Report Question
0%
Cell Address
0%
Worksheet
0%
Formula
True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
Report Question
0%
false
0%
true
How do you select an entire column?
Report Question
0%
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
0:0:1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
0
Answered
0
Not Answered
0
Not Visited
Correct : 0
Incorrect : 0
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqexams.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page