[go: up one dir, main page]
Scribd
Upload
279 views6 pages

Basic Excel Test

The document contains instructions for three tests to be completed in Excel, each requiring specific formatting and calculations. Test 1 involves aligning text, inserting a row, and changing page orientation; Test 2 focuses on calculating profits, totals, and averages; and Test 3 requires formatting a grid and counting salespeople per region. Each test is clearly labeled with specific tasks to be performed.

Uploaded by

ANA LEE MENDOZA
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
279 views6 pages

Basic Excel Test

The document contains instructions for three tests to be completed in Excel, each requiring specific formatting and calculations. Test 1 involves aligning text, inserting a row, and changing page orientation; Test 2 focuses on calculating profits, totals, and averages; and Test 3 requires formatting a grid and counting salespeople per region. Each test is clearly labeled with specific tasks to be performed.

Uploaded by

ANA LEE MENDOZA
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
You are on page 1/ 6

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
TEST 1

Maker Type Class Full Model Name Year Annual Sales (Mil $)
Missam SLX Business Missam SLX 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
Jan Feb Mar Total Average
Sale 120 160 210 490 163.3333
Overhead 100 130 160 390 130
Profit 880

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
Name Region # Orders Sales Regions Orders # People
Bob East 75 $49,017 East >=50 2
Sue East 24 $77,738 West >=50 1
Rishna West 97 $41,107 North >=50 2
Mo North 63 $57,243 South >=50 0
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
in the last column

You might also like