Topics to know for the Windows/Excel Lab Test
You should know how to do these tasks. Not all of them will be
included on the test, but the test tasks will be chosen from this
list.
- Log in to the UK system
- Browse
- Drive names: A, C, D, E - what devices are they?
- Create and use folders (directories) - Understanding a hierarchy
- Describe where a file is - what Path leads to it
- Create a zip file
- see instructions
- Submit a zip file for grading using a browser and Canvas -
Reminder, after you submit (upload) your file, download it immediately and check to see that it has the files you meant to send in the zip file! You can resubmit if you forgot something!
- Log out
- Use Windows to:
- Open, close, and move a window
- Resize and restore a window
- Use the Start menu to run a program
- Click, double click, right click
- Minimize or maximize a window
- Use Windows help
- Empty the recycle bin
- Use Windows Explorer to:
- Create a folder (even nested within a folder)
- Rename a folder or file
- Delete a file
- Find a folder or file
- Expand and collapse folders
- Delete a folder and the files in it
- Cut and paste between windows
- Cut and paste between applications
- Copy files and folders
- Copy files as a group
- Excel
- start Excel
- exit Excel
- open a spreadsheet
- save a spreadsheet and save it with a different name
- make changes or corrections to cells
- select a cell
- enter text
- enter numbers
- enter formulas
- calculate a sum
- understand the order (precedence) of operations - that is, () before *, / before +, -
- be able to turn English descriptions into formulas
- knowing that "product" means "multiply"
- copy formulas using the fill handle
- use a range of cells with a formula
- be able to format cells as dates, currency, percent, number of
decimals
- copy a cell or range of cells to adjacent cells
- insert a row or column
- delete a row or column
- clear a row or column
- use the AutoSum function
- use the Average, Max and Min statistical functions
- display the current date with a date function
- understand absolute versus relative addressing
and be able to use both correctly
- print preview
- change the width of a column
- sort data in a sheet into ascending or descending order
- use the fill handle to create a series like "Monday", "Tuesday", "Wednesday"
- freeze a pane of a sheet at a given cell
- Merge some cells together and center text in them
- Do you know what causes and how to fix a #DIV/0! error?
- Do you know what causes and how to fix a #NUM! error?
- Do you know what causes and how to fix a NAME? error?
- Do you know what causes and how to fix a cell that displays ####?
- Do you know what a circular reference is and how to fix it?
Windows Tutorials