Scribd
Upload
589 views2 pages

Basic Excel Test

The document provides instructions for 3 Excel tests: Test 1 asks to align text right, insert a row, and change page orientation. Test 2 requires calculating profits, totals, and averages. Test 3 instructs formatting a border and determining salespeople per region.

Uploaded by

ryanchristophernavarro2014
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
589 views2 pages

Basic Excel Test

The document provides instructions for 3 Excel tests: Test 1 asks to align text right, insert a row, and change page orientation. Test 2 requires calculating profits, totals, and averages. Test 3 instructs formatting a border and determining salespeople per region.

Uploaded by

ryanchristophernavarro2014
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

INSTRUCTIONS:

There are 3 simple tests for you to go through.


MAKE SURE YOU ARE USING EXCEL.
Please create a new sheet for each test with the right labels.

TEST 1

Maker Type Class Full Mode Year Annual Sales (Mil $)


Missam SLX Business Missam SL 2014 55
Daburo Double Van 2015 60
Tia Jet Van 2013 76
ZMV Cruise Compact 2016 75
Fonda Life Compact 2015 60

Test 1 Instructions
1. Align the text to the right
2. Insert a new row between Missam and Daburo
3. Set the page orientation to landscape

TEST 2

Jan Feb Mar Total Average


Sale 120 160 210
Overhead 100 130 160
Profit

Test 2 Instructions
1. Calculate the profits in row 4
2. Calculate the data for Total column
3. Calculate the average sales, overhead and profit from January to March

TEST 3

Name Region # Orders Sales Regions Orders # People


Bob East 75 $49,017 East >=50
Sue East 24 $77,738 West >=50
Rishna West 97 $41,107 North >=50
Mo North 63 $57,243 South >=50
Dave North 89 $69,496

Test 3 Instructions
1. Format a green-colored border grid for all the cells in the table
2. Determine the number of salesperson per region - indicate your answer in the last column

You might also like