BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
Microsoft Excel
- a spreadsheet software for creating an electronic workbook
- create a simple to complex personal or business workbooks
what does a Workbook consist of?
Consist of rows and columns to organize data, perform calculations, print reports, and
build charts.
-named BookN with numbers assigned in order throughout a work session
Workbook
the file you open, edit and save
What does a workbook contain?
worksheets
-AKA (spreadsheets or a sheet)
Tab
identifier at the bottom left of a worksheet that displays the name of sheet
How to create a new workbook from the backstage view
1. click FILE tab to show Backstage view
2. Select NEW on the left display the NEW AREA in the BACKSTAGE view
3. Click BLANK WORKBOOK to create new blank workbook
Ctrl + N
New Workbook
Save a new workbook
1. FILE tab to show backstage view
2. SAVE AS on left bar
- Ctrl + S
3. Select location to save workbook
- Click RECENT to show recent folders
- ONE DRIVE to see cloud folder names
- THIS PC to save the file to DOCUMENTS
- Click ADD A PLACE to select a commonly used a cloud location
-click BROWSE to open the SAVE AS dialog box
4. click folder name to open it and type its name
5. Click SAVE
F12 (FN + F12)
to open the SAVE AS dialog box
Autosave
-turns on by default when you save file to ONEDRIVE
- automatically saves your work
Ctrl + S
to save
CTRL + W or CTRL + F4
close workbook
, Protected View
when a workbook is opened from the internet or unrecognized source
Enable Editing
when you know it is safe to work with the file
Open a workbook
1. Click FILE tab to open BACKSTAGE view
2. Open to display the open area
3. Select the location and folder where the workbook is stored
4. Locate and click the workbook name
Ctrl + O
open area
Ctrl + F12
displays the OPEN dialog box
Explorer window
double click workbook name to launch excel and open the workbook
Save a workbook under a different name
1. Click the FILE tab to open the BACKSTAGE view
2. Click SAVE AS
3. Navigate to and select the folder name
4. Type of edit the workbook name in the file name area
5. Click SAVE to save the file and return to workbook
.xlsx
the type of file excel is saved as
cell reference
column letter and row number that represent the location of a specific cell; also referred
to as cell address
range
rectangular group of cells such as A1: B3
Gridlines and Headings
to help you identify the location of data
View Tab
you can also display or hide the formula bar and the ruler
label
-Text that displays a name, a title or similar descriptive information
-Labels not included in calculations
value
is a number that can be used in a calculation or is the result of a calculation
formula
is a calculation or expression that displays a result
-Uses arithmetic operator, worksheet cells and constant value
Formula Bar
appears below the ribbon and displays the contents of the selected cell
Active cell
displays a solid border and it appears in the NAME BOX
F2 (FN + F2)
edit mode
GRADED
Microsoft Excel
- a spreadsheet software for creating an electronic workbook
- create a simple to complex personal or business workbooks
what does a Workbook consist of?
Consist of rows and columns to organize data, perform calculations, print reports, and
build charts.
-named BookN with numbers assigned in order throughout a work session
Workbook
the file you open, edit and save
What does a workbook contain?
worksheets
-AKA (spreadsheets or a sheet)
Tab
identifier at the bottom left of a worksheet that displays the name of sheet
How to create a new workbook from the backstage view
1. click FILE tab to show Backstage view
2. Select NEW on the left display the NEW AREA in the BACKSTAGE view
3. Click BLANK WORKBOOK to create new blank workbook
Ctrl + N
New Workbook
Save a new workbook
1. FILE tab to show backstage view
2. SAVE AS on left bar
- Ctrl + S
3. Select location to save workbook
- Click RECENT to show recent folders
- ONE DRIVE to see cloud folder names
- THIS PC to save the file to DOCUMENTS
- Click ADD A PLACE to select a commonly used a cloud location
-click BROWSE to open the SAVE AS dialog box
4. click folder name to open it and type its name
5. Click SAVE
F12 (FN + F12)
to open the SAVE AS dialog box
Autosave
-turns on by default when you save file to ONEDRIVE
- automatically saves your work
Ctrl + S
to save
CTRL + W or CTRL + F4
close workbook
, Protected View
when a workbook is opened from the internet or unrecognized source
Enable Editing
when you know it is safe to work with the file
Open a workbook
1. Click FILE tab to open BACKSTAGE view
2. Open to display the open area
3. Select the location and folder where the workbook is stored
4. Locate and click the workbook name
Ctrl + O
open area
Ctrl + F12
displays the OPEN dialog box
Explorer window
double click workbook name to launch excel and open the workbook
Save a workbook under a different name
1. Click the FILE tab to open the BACKSTAGE view
2. Click SAVE AS
3. Navigate to and select the folder name
4. Type of edit the workbook name in the file name area
5. Click SAVE to save the file and return to workbook
.xlsx
the type of file excel is saved as
cell reference
column letter and row number that represent the location of a specific cell; also referred
to as cell address
range
rectangular group of cells such as A1: B3
Gridlines and Headings
to help you identify the location of data
View Tab
you can also display or hide the formula bar and the ruler
label
-Text that displays a name, a title or similar descriptive information
-Labels not included in calculations
value
is a number that can be used in a calculation or is the result of a calculation
formula
is a calculation or expression that displays a result
-Uses arithmetic operator, worksheet cells and constant value
Formula Bar
appears below the ribbon and displays the contents of the selected cell
Active cell
displays a solid border and it appears in the NAME BOX
F2 (FN + F2)
edit mode
