Flashcards
Bcas Excel Study Guide 2019
Cards in this deck (17)
- 1Know Multiple Ways to Delete text or values from a cella. Backspace Deletes the the selected or one character to the left
b. Delete key Deletes the selected or one character to the Right
c. Undo Button Deletes the content of the cell you are currently working in
d. Esc Key deletes the Content of a Cell are currently working in - 2Know Which side of the cell text and values will align to by default.Values align to the right of the Cell
Text align to the left of the Cell - 3Know the steps to format cells for accounting $Select the range of cells or cell you want to format
Click on accounting button $ in the numbers group of the home ribbon tab - 4Know how to apply a Thick Outside Border to a range of CellsSelect the range of Cells
Click the drop down arrow on the borders button in the font group
Click on the Thick outside Borders - 5Know the difference between worksheet and WorkbookWorksheets are individual tabs in a work book single spreadsheet
a work book is a file with a collection of worksheets. - 6Know the six different ways you could align text or values in a cellLeft, Center, Right, Top, Middle, Bottom
- 7Know what the different Clear options (home tab | Editing group) do and how/when to use them. Know how these are different from the Delete Command and delete key.A . Clears All: Clears Formatting and content of selected Cell(s)
B. Clears Format: Clears the format only of the selected Cell(s)
C. Clear Content: Clears the content only of the cell(s) ; formatting remains.
D. Delete Key: Clears the content only of the selected Cell(S); formatting remains
E. Delete Command: Physically removes cell(s) from the worksheet. - 8Know how to write a formula to add a range of Cells.a. =A1+B1+C1+D1+E1+F1
B.=Sum(A1:F1) - 9Know how to freeze PanesClick on the View Tab
Click on the freeze panes button in the windows group
click when freeze pane option you want: Freeze Panes , top row or Freeze first column - 10Know how to Change the width of a Columna. Right Click on the column label ( or select column, then right click); chose column width, enter column size.
b. Select column; go to the Cells group | Home ribbon and select Format; Column Width or AutoFit column width.
c. Put your cursor between column labels, then click and drag.
d. Double click between the column labels to AutoFit. - 11Know what the fill Handle DoesCan be used to fill in a Series (months, days, years, number pattern) or cell contents without typing everyword
- 12Know multiple ways to add a new worksheets a workbooka. Click the Open button on the QAT
b. Click File| Open
c. Ctrl + O
d. Open File explorer on desktop. Click the folder where the workbook is saved, find the desired workbook, and double click it - 13Know what actions the following keyboard shortcuts and keys perform:Ctrl + End Last Cell in the Worksheet
Ctrl + Home Cell A1
Tab One Cell to the right
Enter one cell down - 14Know the Difference between Filter and SortA Sort will display the contents of the entire database in order to the sort
A Filter will display only the data from the worksheet that meets the requirements of the filter that was applied - 15Know the steps to copy and paste cells1 select the desired cells
2 click copy or use the keyboard command Ctrl + C
3 Click on the first cell where you want to paste the cells
4r click paste or use the keyboard command Ctrl + V. - 16Know how to select an entire columnClick on the column Label ( the Letter)
- 17Know how to rename a worksheet taba. Double click on the tab and type in the new name
b. Right click on the tab, select Rename, and Type new name
Information
- Description
- Flashcards on Bcas Excel Study Guide 2019, created by Matt Pearson on 20/07/2022.
- Created by
- Matt Pearson
- Views
- 1
- Rating